How to: Unprotect all graphic objects on a worksheet.
Solution:
Select the sheet containing the protected objects. Select 'Protection' from the 'Tools' menu and select 'Unprotect Sheet...'.
1) Open the desired workbook.
2) Click the tab for the worksheet that contains the protected graphic objects. (The worksheet is selected.)
3) Select 'Protection' from the 'Tools' menu. (A submenu appears.)
4) Select 'Unprotect Sheet...' from the submenu.
5) If a password was assigned:
a) Type the password in the 'Unprotect Sheet' dialog box.
b) Click 'OK'.